# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 localhost
# Database:             tyms
# Server version:       5.0.27-community
# Server OS:            Win32
# HeidiSQL version:     3.0 RC2 Revision: 55
# --------------------------------------------------------
set NAMES UTF8;
#
# Dumping data for table 'bus_order'
#


#
# Dumping data for table 'customer'
#


#
# Dumping data for table 'customer_company'
#


#
# Dumping data for table 'dictionary_sub'
#


/*!40000 ALTER TABLE dictionary_sub DISABLE KEYS */;
LOCK TABLES dictionary_sub WRITE;
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1',null,'性别','SEX',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('101','1','男','MALE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('102','1','女','FEMALE',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('2',null,'社保状态','SOCIAL_STATUS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('201','2','未注册','NONE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('202','2','已注册','REGISTERING',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('3',null,'学历','DEGREE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('301','3','博士','OTHER',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('302','3','研究生','DOCTOR',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('303','3','本科','MASTER',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('304','3','大专','BACHELOR',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('305','3','高中','SENIOR_HIGH',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('306','3','初中','JUNIOR_HIGH',1);


INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4',null,'公司部门','DEPARTMENT',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('402','4','行政部','ADMINISTRATION',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('403','4','人力资源部','HUMAN_RESOURCE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('404','4','财务部','FINANCIAL',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('405','4','教务部','EDUCATION',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('406','4','内训部','INTERNAL_TRAINING',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('407','4','会议服务中心','CONFERENCE_SERVCE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('408','4','企业规划部','ENTERPRISE_PLANNING',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('409','4','网络技术部','NETWORK_TECHNIQUE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('410','4','课程研发部','COURSE_DEVELOPING',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('411','4','总经理办公室','PRESIDENT_OFFICE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('412','4','项目一部一部','PROJECT_DEPT1_1',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('413','4','项目一部二部','PROJECT_DEPT1_2',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('414','4','项目一部三部','PROJECT_DEPT1_3',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('415','4','项目二部六部','PROJECT_DEPT2_6',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('416','4','项目二部七部','PROJECT_DEPT2_7',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('417','4','项目二部八部','PROJECT_DEPT2_8',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('418','4','项目二部九部','PROJECT_DEPT2_9',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('419','4','助理部','ASSISTANT',1);



INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('5',null,'客户职位','CUSTOMER_TITLE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('501','5','总经理','PRESIDENT',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('502','5','主管','SUPERVISOR',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('503','5','法人代表','COMPANY_REPRESENT',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('6',null,'项目类型','ORDER_PROJECT_TYPE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('601','6','书籍项目','ORDER_PROJECT_TYPE_BOOK',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('602','6','公开课项目','ORDER_PROJECT_TYPE_PUBLIC_COURSE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('603','6','内训项目','ORDER_PROJECT_TYPE_INNER_TRANING',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('604','6','工具书项目','ORDER_PROJECT_TYPE_TOOL_BOOK',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('7',null,'薪资','SALARY_TPYE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('701','7','试用','INTERN',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('702','7','正式','EMPLOYEE',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('8',null,'婚姻状况','MARRIAGEMENT_STATE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('801','8','未婚','NOT_MARRIED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('802','8','已婚','MARRIED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('803','8','其它','DIVORCED',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('9',null,'社保办理状态','SOCIAL_SECURITY_STATUS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('901','9','已办理','TRANSACTED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('902','9','未办理','NOT_TRANSACTED',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('10',null,'社保卡领取状态','SOCIAL_SECURITY_CARD_STATUS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1001','10','已领取','RECIEVED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1002','10','未领取','NOT_RECIEVED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1003','10','无','NONE',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('11',null,'医保卡领取状态','HEALTH_SECURITY_CARD_STATUS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1101','11','已领取','RECIEVED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1102','11','未领取','NOT_RECIEVED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1103','11','无','NONE',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('12',null,'培训状态','TRAINING_STATE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1201','12','已培训','TRAINED',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1202','12','未培训','NOT_TRAINED',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('13',null,'户口类别','REGISTERED_RESIDENSE_TYPE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1301','13','本市城镇','',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1302','13','本市农村','',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1303','13','外地城镇','',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1304','13','外地农村','',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('14',null,'社保人员类型','SOCIAL_SECURITY_TYPE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1401','14','外地农民工','OUT_TOWN_WORKER',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1402','14','外阜城镇职工','OTHER_TOWN_WORKER',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1403','14','外地农村劳动力','COUNTRY_LABOR',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1404','14','本市职工','DOWN_TOWN_WORKER',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1405','14','本市农村劳动力','COUNTRY_LABOR_OF_THIS_CITY',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('15',null,'参保种类','SOCIAL_SECURITY_SORT',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1501','15','养老 医疗 工伤','SECURITY_3',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1502','15','四险 ','SECURITY_4',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1503','15','五险','SECURITY_5',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('16',null,'社保单位','SOCIAL_SECURITY_COMPANY',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1601','16','北京天元鸿鼎管理咨询有限公司','SECURITY_COMPANY_1',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1602','16','北京天元盛世会议会展有限公司 ','SECURITY_COMPANY_2',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1603','16','北京天元智尚教育科技有限公司','SECURITY_COMPANY_3',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1604','16','北京天元聚泰文化发展有限公司','SECURITY_COMPANY_4',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('17',null,'订单状态','ORDER_STATUS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1701','17','预售','ORDER_STATUS_PRESALES',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1702','17','已签单','ORDER_STATUS_DEALED',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('18',null,'是否统招','UNIFIED_ENTRANCE',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1801','18','统招','UNIFIED_ENTRANCE',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1802','18','非统招','NON_UNIFIED_ENTRANCE',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('19',null,'离职手续是否办理','QUIT_JOB_PAPERS',0);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1901','19','已办理','QUIT_JOB_PAPERS',1);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('1902','19','未办理','NO_QUIT_JOB_PAPERS',1);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49121','412','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49122','412','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49123','412','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49124','412','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49125','412','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49126','412','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49131','413','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49132','413','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49133','413','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49134','413','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49135','413','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49136','413','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49141','414','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49142','414','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49143','414','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49144','414','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49145','414','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49146','414','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49151','415','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49152','415','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49153','415','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49154','415','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49155','415','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49156','415','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49161','416','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49162','416','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49163','416','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49164','416','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49165','416','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49166','416','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49171','417','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49172','417','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49173','417','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49174','417','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49175','417','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49176','417','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49181','418','项目经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49182','418','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49183','418','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49184','418','业务总工程师','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49185','418','销售代表','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('49186','418','销售助理','',2);

INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('497','402','经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('498','402','副主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('499','402','行政文员A岗','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4910','402','行政文员B岗','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4911','403','经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4912','403','人事专员','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4913','403','人事助理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4914','404','财务总监','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4915','404','主任','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4916','404','总监助理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4917','404','员工','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4918','405','教务管理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4919','406','内训咨询专员','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4920','407','经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4921','407','会务管理A岗','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4922','407','会务管理B岗','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4923','410','市场调研','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4924','410','课程设计','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4925','411','总经理','',2);
INSERT INTO dictionary_sub (DICTIONARY_ID, PARENT_ID, DICTIONARY_NAME, CODE, NODE_LEVEL) VALUES ('4926','411','总经理助理','',2);
UNLOCK TABLES;
/*!40000 ALTER TABLE dictionary_sub ENABLE KEYS */;



#
# Dumping data for table 'employee'
#


#
# Dumping data for table 'function'
#

/*!40000 ALTER TABLE function DISABLE KEYS */;
LOCK TABLES function WRITE;
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('1','基础数据维护',NULL,'','','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('102','员工信息','1','employee/employee.action','/employee','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('103','客户信息','1','customerCompany/customerCompany.action','/customerCompany','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('104','角色维护','1','role/role.action','/permission','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('105','数据字典','1','dictionary/main','/dictionary','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('2','项目管理',NULL,'','','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('202','客户项目订单管理','2','order/orders','/order','');
INSERT INTO function (FUNCTION_ID, FUNCTION_NAME, PARENT_ID, ROOT_URL, NAME_SPACE, IS_DEFAULT) VALUES ('203','客户项目订单查询','2','order/search','/order','');
UNLOCK TABLES;
/*!40000 ALTER TABLE function ENABLE KEYS */;

#
# Dumping data for table 'role'
#

/*!40000 ALTER TABLE role DISABLE KEYS */;
LOCK TABLES role WRITE;
INSERT INTO role (ROLE_ID, ROLE_NAME, IS_ADMIN) VALUES ('1','管理员',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE role ENABLE KEYS */;

#
# Dumping data for table 'permission'
#

/*!40000 ALTER TABLE permission DISABLE KEYS */;
LOCK TABLES permission WRITE;

UNLOCK TABLES;
/*!40000 ALTER TABLE permission ENABLE KEYS */;

#
# Dumping data for table 'user'
#

/*!40000 ALTER TABLE user DISABLE KEYS */;
LOCK TABLES user WRITE;
INSERT INTO user (USER_ID, LOGIN_ID, LOGIN_PWD, CREATED_DATE, LAST_MODIFIED, ROLE_ID) VALUES ('1','admin','111111','1899-12-30 19:00:00','1899-12-30 19:00:00','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE user ENABLE KEYS */;


/*!40000 ALTER TABLE project_attribute DISABLE KEYS */;
LOCK TABLES project_attribute WRITE;
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'时间（年/月）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'书籍名称或项目编号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'数量（套）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'报名单位');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'发票名称');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'单价');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'总计套');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'金额总计');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'回执日期');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'到款时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'到款金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'到款账户');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'开票时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'开票明细');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'开票金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'寄出书');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'寄出发票');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'寄出方式');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'联系人');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'联系电话');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'单位地址');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'货运单号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'发票单号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'退书时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'退书数量');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'退书运费');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'是否补款');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'是否已算业绩');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'重开票信息');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'是否补税');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (601,'备注');

INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'课程名称或项目编号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'日期（年月日）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'会议地址');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'学习金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'考察金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'全款人数');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'参会人数');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'考察人数');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'费用小计');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'回执日期');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'汇款金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'汇款时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'汇款账户');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'现金收款');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'发票时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'发票内容');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'发票金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'住宿情况');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'是否压款');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'是否退款');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'是否退票');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'是否换票');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'是否业绩');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'参会人员姓名');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'参会人员职务');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'参参会人员联系电话');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'本次项目给予的优惠');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (602,'备注');


INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'课题名称或项目编号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'实施时间（年月日）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'合同签订时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'合同编号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'内训地点');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'天数');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'项目总额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'主讲老师');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'内训负责人');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'业务部负责人');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'是否已算业绩');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'汇款金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'汇款时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'汇款账户');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'发票时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'发票内容');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'发票金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'教务负责人');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'参会人员职务');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'企业培训负责人姓名');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'企业培训负责人电话');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'企业培训负责人邮箱');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (603,'备注');

INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'时间（年/月）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'书籍名称或项目编号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'数量（套）');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'报名单位');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'发票名称');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'单价');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'总计套');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'金额总计');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'回执日期');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'到款时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'到款金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'到款账户');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'开票时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'开票明细');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'开票金额');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'寄出书');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'寄出发票');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'寄出方式');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'联系人');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'联系电话');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'单位地址');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'货运单号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'发票单号');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'退书时间');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'退书数量');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'退书运费');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'是否补款');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'是否已算业绩');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'重开票信息');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'是否补税');
INSERT INTO project_attribute (PROJECT_TYPE_ID, ATTR_NAME) VALUES (604,'备注');

UNLOCK TABLES;
/*!40000 ALTER TABLE project_attribute ENABLE KEYS */;
LOCK TABLES report_field WRITE;
# 导出列
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'employeeNumber', '员工编号', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'employeeName', '员工姓名', NULL);

INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'politicalStatus', '政治面貌', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'timeOfEmployment', '入职日期', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'registeredResidenceType.dictionaryName', '户口类别', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'registerTime', '转正日期', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'email', 'E-mail', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialStatus.dictionaryName', '社保状态', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'phoneNumber', '手机号码', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityStatus.dictionaryName', '社保办理状态', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'homePhoneNumber', '家庭电话', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'announcedSalary', '申报工资', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'businessName', '业务名', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'address', '身份证住址', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityTime', '社保办理日期', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'department.dictionaryName', '部门', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'currentlyAddress', '现住址', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityCompany.dictionaryName', '社保单位', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'position.dictionaryName', '职位', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'internSalary', '试用期薪资', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityType.dictionaryName', '社保人员类型', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'employeeClass', '级别', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'performanceSalary', '转正薪资', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecuritySort.dictionaryName', '参保种类', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialId', '身份证号', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'performanceSalary', '绩效工资', NULL);

INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityCardStatus.dictionaryName', '社保卡领取状态', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'performanceSalary', '绩效工资', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'sex.dictionaryName', '性别', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'marriagementState.dictionaryName', '婚姻状况', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'socialSecurityCardStatus.dictionaryName', '医保卡领取状态', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'ethnic', '民族', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'graduatedSchool', '毕业院校', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'onBoardWay', '招聘渠道', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'birthPlace', '籍贯', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'degree.dictionaryName', '学历', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'graduatedMajor', '专业', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'timeOfLeaving', '离职时间', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'age', '年龄', NULL);

INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'quitJobPapers.dictionaryName', '离职手续是否办理', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'birthday', '出生日期', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'unifiedEntrance.dictionaryName', '是否统招', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'contactInBJ', '紧急联系人', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'chineseBirthday', '农历生日', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'graduatedTime', '毕业时间', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'phoneOfContactInBJ', '紧急联系人电话', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'userInfo.role.roleName', '角色', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'userInfo.loginId', '登陆账户', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'userInfo.loginPwd', '登陆密码', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'bankCard', '工资卡', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'contract', '劳动合同', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'trainingLog', '培训记录', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'experience', '工作经历', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'credential', '资格证书', NULL);

INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'punishmentRecord', '惩罚记录', NULL);
INSERT INTO report_field ( REPORT_TYPE, FIELD_WIDTH, FIELD_NAME, FIELD_LABEL, CSS_STYLE) VALUES( 0, 100, 'remarks', '员工备注', NULL);

UNLOCK TABLES;

	

